cd $ORACLE_HOME/network/admin

ls -l

lsnrctl status

lsnrctl start

lsnrctl start [nazwa_listenera]



Serwisy bazodanowe

sql / as sysdba

ALTER SESSION SET CONTAINER=PDB1;

EXEC DBMS_SERVICE.CREATE_SERVICE('HR_SRV', 'HR_SRV');

EXEC DBMS_SERVICE.START_SERVICE('HR_SRV');

ALTER PLUGGABLE DATABASE PDB1 SAVE STATE;

SELECT CON_ID, PDB, NETWORK_NAME FROM CDB_SERVICES;

SELECT NAME, NETWORK_NAME FROM V$ACTIVE_SERVICES;

lsnrctl status

sql HR@//localhost:1521/HR_SRV

SELECT USER FROM DUAL;

SHOW CON_NAME

sql / as sysdba

ALTER SESSION SET CONTAINER=PDB1;

EXEC DBMS_SERVICE.DISCONNECT_SESSION('HR_SRV');

EXEC DBMS_SERVICE.STOP_SERVICE('HR_SRV');

EXEC DBMS_SERVICE.DELETE_SERVICE('HR_SRV');

SELECT CON_ID, PDB, NETWORK_NAME FROM CDB_SERVICES;

cd $ORACLE_HOME/network/admin

ls -l

tnsping db01



